<html xmlns="http://www.w3.org/1999/xhtml" xmlns:htmldb="http://htmldb.oracle.com" lang="es"><head>


<script src="ALTER%20cliente%20y%20empleado_files/htmldb_html_elements.js" type="text/javascript"></script>
<script src="ALTER%20cliente%20y%20empleado_files/htmldb_get.js" type="text/javascript"></script>
<script language="JavaScript" type="text/javascript">
<!--
/*Global JS Variables*/
var htmldb_Img_Dir = "/i/";
//-->
</script>
<link rel="stylesheet" href="ALTER%20cliente%20y%20empleado_files/core.css" type="text/css">
<style type="text/css">
<!-- 

#R137341724550811368{display:none;}
#R137341724550811368_show{}
a.indexUsed,a.indexUsed:link,a.indexUsed:visited{font-weight:bold;color:#333333}
span.highLight{color:#2F9F58;font-weight:bold;}
.fielddatabold{padding-left:7px;}
span.noIndex{font-weight:bold;color:#ff0000;}
 -->
</style>
<script>

function p1003_RunButton(){

html_TabClick(html_GetElement('result_tab'),'resultsHolder');
var pCall="sc_getResults('3355686696429942')";
setTimeout(pCall,100);


}

</script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="ALTER%20cliente%20y%20empleado_files/htmldb_V2.css" type="text/css">
<script src="ALTER%20cliente%20y%20empleado_files/sc_slider.js" type="text/javascript"></script>
<script src="ALTER%20cliente%20y%20empleado_files/sc_core.js" type="text/javascript"></script>
<script language="JavaScript1.1" type="text/javascript">
document.onkeypress  = sc_quickKeys;
</script>
<title>Comandos SQL</title>
<style type="text/css">
     #htmldbRunEditZag{border:none;} 
    .htmldbRunEditRegion{display:none;}
</style>
</head><body style="cursor: default;" onload="first_field(); sc_PageInit()" onbeforeunload="sc_removeJob()"><noscript>Debe ejecutar este producto con JavaScript activado.</noscript><form action="wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm">
  <input name="p_flow_id" value="4500" id="pFlowId" type="hidden">  <input name="p_flow_step_id" value="1003" id="pFlowStepId" type="hidden">  <input name="p_instance" value="3355686696429942" id="pInstance" type="hidden">  <input name="p_page_submission_id" value="327625" id="pPageSubmissionId" type="hidden">  <input name="p_request" value="" id="pRequest" type="hidden"><a name="PAGETOP"></a><script language="JavaScript" type="text/javascript"> 
var g_Saved="Consulta Guardada.";
var gUser="SPA";
</script>
<a id="htmldbLogo2" href="http://127.0.0.1:8080/apex/f?p=4500:1000:3355686696429942"><img src="ALTER%20cliente%20y%20empleado_files/oracle_xe_logo.gif" alt="Application Express" width="300" height="30"></a><a href="javascript:popupURL('wwv_flow_help.show_help?p_lang=es&amp;p_session=3355686696429942&amp;p_flow_id=4501&amp;p_step_id=1003,4501');" class="htmldbNavLink"><img src="ALTER%20cliente%20y%20empleado_files/navbar_help.gif" alt="Ayuda de Tarea" class="htmldbNavLink">Ayuda</a><a href="http://127.0.0.1:8080/apex/wwv_flow_custom_auth_std.logout?p_this_flow=4500&amp;p_next_flow_page_sess=4550:8:3355686696429942" class="htmldbNavLink"><img src="ALTER%20cliente%20y%20empleado_files/navbar_logout.gif" alt="Desconectar" class="htmldbNavLink">Desconectar</a><a href="http://127.0.0.1:8080/apex/f?p=4500:1000:3355686696429942:::::" class="htmldbNavLink"><img src="ALTER%20cliente%20y%20empleado_files/navbar_home.gif" alt="Inicio" class="htmldbNavLink">Inicio</a>
<div class="htmldbSep"><br></div>
<div id="htmldbUser">Usuario: SPA<span id="htmldbWorkspace"></span></div>
<div id="htmldbPageTabs"></div>
<div id="htmldbBreadcrumbTop"><br></div>
<table class="htmldbLayout" summary="" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td class="htmldbBreadcrumbRegion"><div class="htmldbBreadcrumbs"><a href="http://127.0.0.1:8080/apex/f?p=4500:1000:3355686696429942::NO:::" class="htmldbBreadcrumb">Inicio</a><span class="htmldbBreadcrumbSep">&gt;</span><a href="http://127.0.0.1:8080/apex/f?p=4500:3002:3355686696429942::NO:::" class="htmldbBreadcrumb">SQL</a><span class="htmldbBreadcrumbSep">&gt;</span><span class="htmldbBreadcrumb">Comandos SQL</span><span id="htmldbCustomize"></span></div></td>
<td rowspan="2" class="htmldbRunEditRegion"><table summary=""><tbody><tr><td align="right" nowrap="nowrap"><label for="P1003_SCHEMA"><a class="htmldbGALabel" href="javascript:popupFieldHelp('11765804246007547.4501','3355686696429942','Cerrar')" tabindex="999">Esquema</a></label></td>
<td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="11765804246007547" type="hidden">
<select name="p_t01" size="1" id="P1003_SCHEMA" class="htmldbTopSchema">
<option selected="selected" value="SPA">SPA</option>
</select>
</td></tr>
</tbody></table>
</td></tr>
<tr>
<td id="htmldbRunEditZag"><img src="ALTER%20cliente%20y%20empleado_files/1px_trans.gif" alt="" width="1" height="6"></td>
</tr>
</tbody></table><a name="SkipRepNav"></a><div id="htmldbMessageHolder" style="margin: 0px; padding: 0px;"></div>
<table style="height: 462.75px; width: 1253px;" summary="" id="SqlAndResults" width="100%" align="center" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td valign="top">
<div id="scRightHeader"><table summary="" class="htmldbButtonPositionsOnly" id="R149883011479458110" border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td width="100%"><table summary=""><tbody><tr><td align="right" nowrap="nowrap"><label for="P1003_AUTOCOMMIT"><a class="htmldbLabelOptional" href="javascript:popupFieldHelp('136320022504169238.4501','3355686696429942','Cerrar')" tabindex="999"></a></label></td>
<td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="136320022504169238" type="hidden">
<input name="p_v02" value="Y" checked="checked" onclick="this.blur();" onchange="sc_toggleJob(this);" id="P1003_AUTOCOMMIT_0" type="checkbox"><span class="fielddata"><label for="P1003_AUTOCOMMIT_0">Confirmación Automática</label></span>&nbsp;&nbsp;&nbsp;<label for="P1003_ROWS"><a class="htmldbGALabel" href="javascript:popupFieldHelp('138940226594571588.4501','3355686696429942','Cerrar')" tabindex="999">Mostrar</a></label><input name="p_arg_names" value="138940226594571588" type="hidden">
<select name="p_t03" size="1" id="P1003_ROWS">
<option value="10">10</option>
<option value="15">15</option>
<option value="20">20</option>
<option selected="selected" value="30">30</option>
<option value="50">50</option>
<option value="100">100</option>
<option value="200">200</option>
<option value="500">500</option>
<option value="1000">1000</option>
<option value="5000">5000</option>
<option value="10000">10000</option>
<option value="100000">100000</option>
</select>
</td></tr>
</tbody></table>
</td>
<td style="padding-right: 25px;"><input onclick="javascript:sc_popup('saveDialog');" value="Guardar" class="htmldbButton" type="button"></td>
<td></td>
<td><input onclick="javascript:p1003_RunButton();" value="Ejecutar" class="htmldbButton" type="button"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr></tbody></table></div>
<div style="overflow: hidden; height: 228.375px; width: 1253px;" id="scCommandHolder" class="d1"><textarea style="width: 1253px; height: 218px;" name="p_t04" cols="30" rows="4" wrap="virtual" id="P1003_SQL_COMMAND1">ALTER TABLE CLIENTE ADD STATUS VARCHAR2(10) DEFAULT 'ACTIVO'

ALTER TABLE EMPLEADO ADD STATUS VARCHAR2(10) DEFAULT 'ACTIVO'



ALTER TABLE CLIENTE ADD (CONSTRAINT CH_STATUS_CLIENTE CHECK (STATUS IN ('ACTIVO', 'INACTIVO')))

ALTER TABLE EMPLEADO ADD (CONSTRAINT CH_STATUS_EMPLEADO CHECK (STATUS IN ('ACTIVO', 'INACTIVO')))

</textarea>
<table summary=""><tbody><tr><input name="p_arg_names" value="1010404642163039" type="hidden">
</tr></tbody></table>
</div>
<div style="width: 1253px;" id="h_slide"><br></div>
<div style="width: 1253px;" id="scBottomHolder"><table class="htmldbTabbedNavigationList" border="0" cellpadding="0" cellspacing="0"><tbody><tr>

<td valign="bottom"><a href="#" class="tabcurrent" id="result_tab" onclick="html_TabClick(this,'resultsHolder');return false;">Resultados</a></td>

<td valign="bottom"><a class="" href="#" id="explain_tab" onclick="sc_getPlan();html_TabClick(this,'explainHolder');return false;">Explicar</a></td>
<td valign="bottom"><a class="" href="#" id="describe_tab" onclick="sc_getDesc();html_TabClick(this,'describeHolder');return false;">Describir</a></td>
<td valign="bottom"><a class="" href="#" id="savedsql_tab" onclick="sc_getSavedSQL();html_TabClick(this,'SavedSQLHolder');return false;">SQL Guardado</a></td>
<td valign="bottom"><a class="" href="#" id="history_tab" onclick="sc_DisplayHist();html_TabClick(this,'historyHolder');return false;">Historial</a></td>
<td width="100%"><br></td></tr></tbody></table>
<div style="width: 1253px;" id="htmlTabHolder"><div style="" id="resultsHolder" class="fielddata"><div id="BOX_BODY"><table summary=""><input name="p_arg_names" value="4417028828681705" type="hidden">
<input name="p_t01" value="6" id="P1200_ROWS" type="hidden">
<input name="p_arg_names" value="4418303464693368" type="hidden">
<input name="p_t02" value="ALTER TABLE EMPLEADO ADD (CONSTRAINT CH_STATUS_EMPLEADO CHECK (STATUS IN ('ACTIVO', 'INACTIVO')))" id="P1200_PREV_SQL" type="hidden">
<input name="p_arg_names" value="21572909937200807" type="hidden">
<input name="p_t03" value="" id="P1200_ACTION" type="hidden">
<input name="p_arg_names" value="21606912080381235" type="hidden">
<input name="p_t04" value="" id="P1200_BINDS" type="hidden">
<input name="p_arg_names" value="21736625668766618" type="hidden">
<input name="p_t05" value="" id="P1200_BIND_VALS" type="hidden">
<tbody><tr><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="141063525539678026" type="hidden">
<input name="p_t06" value="" id="P1200_TYPE" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="141446907512589228" type="hidden">
<input name="p_t07" value="" id="P1200_STMT" type="hidden">
</td></tr></tbody></table>
<pre>
Tabla modificada.
</pre>
<br><span style="font-size: 13px;">               0,03 segundos</span><table class="htmldbShowHide" summary="" id="R137341724550811368" border="0" cellpadding="0" cellspacing="0">
<thead id="headR137341724550811368">
<tr>
<th class="htmldbShowHide"><span onclick="htmldb_ToggleTableBody('iR137341724550811368','bodyR137341724550811368')"><img src="ALTER%20cliente%20y%20empleado_files/rollup_plus_dgray.gif" class="pseudoButtonActive" id="iR137341724550811368" alt="">Salida de DBMS</span></th>
</tr>
</thead>
<tbody style="display: none;" id="bodyR137341724550811368">
<tr><td class="htmldbShowHide"><div id="DBMS_OUTPUT_DIV">&nbsp;</div></td></tr>
</tbody>
</table><table summary=""><tbody><tr><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="11141129549203626" type="hidden">
<input name="p_t08" value="" id="OB_OBJECT_NAME" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="11143605700225196" type="hidden">
<input name="p_t09" value="" id="P0_PPRTIMESTAMP" type="hidden">
</td></tr></tbody></table>
</div></div><div id="explainHolder" style="display: none;"></div><div id="describeHolder" style="display: none;"></div>




<script style="display: none;" language="JavaScript1.1" type="text/javascript">
     <!-- Comment out script for old browsers
 function filter_escape(in_value) {
                out_value = escape( in_value );
                return out_value;
            }
        function genList0_p_t02_4(filter)
         {
         
pUrl = "wwv_flow_utilities.gen_popup_list";
pUrl += "?p_filter="  + filter_escape(filter.value);
pUrl += "&p_name=" + escape('p_t02');
pUrl += "&p_element_index=" + escape('4');
pUrl += "&p_form_index=" + escape('0');
pUrl += "&p_max_elements=" + escape('');
pUrl += "&p_escape_html=" + escape('');
pUrl += "&p_ok_to_query=" + escape('YES');
pUrl += "&p_flow_id=" + escape('4500');
pUrl += "&p_page_id=" + escape('139');
pUrl += "&p_session_id=" + escape('3355686696429942');
pUrl += "&p_eval_value=" + escape('');
pUrl += "&p_translation=" + escape('N');
pUrl += "&p_lov=" + filter_escape('select owner||\'.\'||object_name d,owner||\'.\'||object_name r  from all_objects   where object_type = :p139_type   and object_name not like \'BIN%\'   and object_name not like \'DR$%\'   order by 1');
pUrl += "&p_lov_checksum=11C9E09D7D7595D2A70B20B404698D22";
cDebug(pUrl)
           w = open(pUrl,"winLovList","Scrollbars=1,resizable=1,width=400,height=500");
           if (w.opener == null)
             w.opener = self;
           w.focus();
         }//-->
     </script><div id="historyHolder" style="display: none;"></div><div id="SavedSQLHolder" style="display: none;"></div></div></div>  
</td>
</tr>
</tbody></table>
<table summary=""><tbody><tr><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="1009422172158645" type="hidden">
<input name="p_t05" value="ALTER TABLE EMPLEADO ADD (CONSTRAINT CH_STATUS_EMPLEADO CHECK (STATUS IN ('ACTIVO', 'INACTIVO')))" id="P1003_SQL_COMMAND2" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="6499004703108337" type="hidden">
<input name="p_t06" value="" id="P1003_QUERY_ID" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="22427709467385060" type="hidden">
<input name="p_t07" value="" id="P1003_DESC_OBJ" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="22928616063638920" type="hidden">
<input name="p_t08" value="0" id="P1003_POPUP" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="22929809614646511" type="hidden">
<input name="p_t09" value="" id="P1003_RETURN_INTO" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="136534514172415835" type="hidden">
<input name="p_t10" value="" id="P1003_JOBID" type="hidden">
</td></tr>
</tbody></table>
<table style="border: 1px solid rgb(0, 0, 0); padding: 0px; display: none; position: absolute; background-color: rgb(238, 238, 238); text-align: center; font-size: 12px; color: rgb(0, 0, 0);" summary="" id="R6464923591877238" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td class="htmldbWizardHeader">Guardar SQL</td>
<td class="htmldbWizardHeader" align="right"><span onclick="dhtml_CloseDialog(this);"><img src="ALTER%20cliente%20y%20empleado_files/vertical_close.png"></span></td>
</tr>
<tr>
<td colspan="2" class="htmldbWizardBody"><div id="saveDialog"><table summary=""><tbody><tr><td align="right" nowrap="nowrap"><label for="P1003_SAVE_NAME"><a class="htmldbLabelRequired" href="javascript:popupFieldHelp('6470812902902555.4501','3355686696429942','Cerrar')" tabindex="999"><img src="ALTER%20cliente%20y%20empleado_files/requiredicon_status2.gif" alt="">Nombre</a></label></td>
<td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="6470812902902555" type="hidden">
<input name="p_t11" size="30" maxlength="2000" id="P1003_SAVE_NAME" type="text">
</td></tr><tr><td align="right" nowrap="nowrap" valign="top"><label for="P1003_SAVE_DESC"><a class="htmldbLabelOptional" href="javascript:popupFieldHelp('6471725716906222.4501','3355686696429942','Cerrar')" tabindex="999">Descripción</a></label></td>
<td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="6471725716906222" type="hidden">
<textarea name="p_t12" cols="30" rows="2" wrap="virtual" id="P1003_SAVE_DESC"></textarea>
</td></tr>
</tbody></table>
</div></td>
</tr>
<tr>
<td colspan="2" align="right"><input onclick="javascript:sc_CancelSave();" value="Cancelar" class="htmldbButton" type="button">&nbsp;&nbsp;&nbsp;<input onclick="javascript:sc_saveSql();" value="Guardar" class="htmldbButton" type="button"></td>
</tr>
</tbody></table><table summary=""><tbody><tr><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="11141129549203626" type="hidden">
<input name="p_t13" value="" id="OB_OBJECT_NAME" type="hidden">
</td><td></td><td colspan="1" rowspan="1" align="left"><input name="p_arg_names" value="11143605700225196" type="hidden">
<input name="p_t14" value="" id="P0_PPRTIMESTAMP" type="hidden">
</td></tr></tbody></table>

<div class="htmldbFlowV">Application Express 2.1.0.00.39</div>
<div class="htmldbNewBottom">
<div class="htmldbNewBottom1">Idioma: es</div>
<div class="htmldbNewBottom2">Copyright © 1999, 2006, Oracle. Todos los Derechos Reservados.</div>
<br style="clear: both;">
</div>
<input name="p_md5_checksum" value="" type="hidden"></form>
<a name="END"><br></a>
<script language="JavaScript1.1" type="text/javascript">
    first_field('P1003_SQL_COMMAND1');
</script>
</body></html>